Skip to content

Microsoft Access 2019 Expert

Self-paced with tutor support.


Pitman Training North London & Hertfordshire

Summary

Price
£399 inc VAT
Finance options

4, 6, 10 and 12 Month Interest Free Payment Plan Options Available.

Speak to one of our expert...

Study method
Online
Duration
25 hours · Self-paced
Qualification
No formal qualification
CPD
25 CPD hours / points
Certificates
  • Microsoft Access 2019 Expert - Free
Additional info
  • Exam(s) / assessment(s) is included in price
  • Tutor is available to students

Add to basket or enquire

Overview

ABOUT THE COURSE

The course offers an exciting and innovative approach to Access training. It consists of 14 modules and includes media demonstrations,hands-on activities, and knowledge check questions. At the end of the course, you will complete a consolidation exercise, which will help you review what you have learned and assess your understanding. The course also contains quizzes at the end of each module and a Validation Test at the end
of the course. With successful completion of the course, you will receive a Pitman Training certificate to verify your achievement.

AIMS AND OBJECTIVES

The aim of the course is for you to learn advanced-level concepts and features of the Microsoft Access 2019 atabase management application, so that you will be effective in creating, using, and managing databases.

CPD

25 CPD hours / points
Accredited by The CPD Standards Office

Course media

Description

COURSE CONTENT

Module 1: Primary Keys and Indexes

Module 2: The Ribbon

Module 3: Using Datasheet View

Module 4: Linking Other Access Databases

Module 5: Using ODBC and SQL Server

Module 6: Splitting an Access Database

Module 7: Macros

Module 8: Introduction to Visual Basic for Applications

Module 9: Visual Basic for Application Coding

Module 10: Access Events Model

Module 11: Forms

Module 12: Advanced Uses of Queries

Module 13: Action Queries

Module 14: Packaging Your Application

Who is this course for?

The course is designed for those who are familiar with Microsoft Access 2019 and who want to learn advanced concepts and techniques to work more productively with the software.

Requirements

This course follows Access 2019.

Career path

Microsoft Access is a very popular database application widely used across many employment sectors to keep
accurate, up-to-date records of customers, projects, products, etc. Knowing how to effectively set up and manage databases will be a valuable skillset in many work environments.

Questions and answers

Certificates

Microsoft Access 2019 Expert

Digital certificate - Included

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.